﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[proc_ZzjgSelect]
	(
	@pid VARCHAR(100)	
	)
AS
BEGIN	
    --查询下级结点
	SELECT * FROM zzjg WHERE LEN(bh)=LEN(@pid)+2 AND bh like @pid+'%' ORDER BY sort
END
